package com.example.denglu.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.denglu.dto.UserInformationExcelDto;
import org.apache.ibatis.annotations.Param;

import com.example.denglu.entity.UserInformation;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface UserInformationMapper extends BaseMapper<UserInformation> {

    List<UserInformation> findAllByDeleted(@Param("deleted") int deleted);

    int deleteByName(@Param("name") String name);

    void updateDeletedByName(@Param("deleted") int deleted, @Param("name") String name);

   UserInformation selectByName(@Param("name") String name);

    List<UserInformation> selectByGender(@Param("gender") String gender);

    List<UserInformation> selectByPosition(@Param("position") String position);

    int insertSelective(UserInformation userInformation);

    List<UserInformationExcelDto> Download(@Param("deleted") int deleted);

    List<UserInformation> findByKeyWord(@Param("keyWord") String keyWord);



}
